/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-22 22:24:07
*/


-- ----------------------------
-- Table structure for tb0074
-- ----------------------------
DROP TABLE [dbo].[tb0074]
GO
CREATE TABLE [dbo].[tb0074] (
[ID] int IDENTITY(1,1) NOT NULL,
[UserID] varchar(20) NOT NULL  ,
[UserName] varchar(100) NULL ,
[Password] varchar(100) NULL ,
[Disabled] bit NOT NULL DEFAULT ((0)) ,
[CreateUserID] varchar(20) NULL ,
[CreateDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL 
)


GO

-- ----------------------------
-- Primary Key structure for table tb0074
-- ----------------------------
ALTER TABLE [dbo].[tb0074] ADD PRIMARY KEY NONCLUSTERED ([UserID])
GO

INSERT INTO tb0074([UserID],UserName, [Password],[Disabled], CreateUserID, CreateDate,LastModifyUserID, LastModifyDate) VALUES('ADMIN','ADMIN','',0,'CREATER',GETDATE(),'CREATER',GETDATE())

GO         
